﻿using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace CoreShop.Model
{
    /// <summary>
    /// 商品库存
    /// </summary>
    public class corecmsfoodtotal
    {
        /// <summary>
        /// 序列
        /// </summary>
        [SqlSugar.SugarColumn(ColumnName = "id", IsPrimaryKey = true, IsIdentity = true)]
        public Int64 id { get; set; }


        /// <summary>
        /// 品牌id
        /// </summary>
        [SqlSugar.SugarColumn(ColumnName = "corpId", IsNullable = false)]
        public Int32 corpId { get; set; }

        /// <summary>
        /// 门店id
        /// </summary>
        [SqlSugar.SugarColumn(ColumnName = "storeId", IsNullable = false)]
        public Int32 storeId { get; set; }

        /// <summary>
        /// 商品id
        /// </summary>
        [SqlSugar.SugarColumn(ColumnName = "foodId", IsNullable = false)]
        public Int64 foodId { get; set; }

        /// <summary>
        /// 商品规格Id
        /// </summary>
        [SqlSugar.SugarColumn(ColumnName = "foodSpecId", IsNullable = false)]
        public Int64 foodSpecId { get; set; }

        /// <summary>
        /// 数量
        /// </summary>
        [SqlSugar.SugarColumn(ColumnName = "qty", IsNullable = false)]
        public Decimal qty { get; set; }

        /// <summary>
        /// 价格
        /// </summary>
        [SqlSugar.SugarColumn(ColumnName = "price", IsNullable = false)]
        public Decimal price { get; set; }

        /// <summary>
        /// 最小库存
        /// </summary>
        [SqlSugar.SugarColumn(ColumnName = "minQty", IsNullable = false)]
        public Decimal minQty { get; set; }

        /// <summary>
        /// 最大库存
        /// </summary>
        [SqlSugar.SugarColumn(ColumnName = "maxQty", IsNullable = false)]
        public Decimal maxQty { get; set; }

        /// <summary>
        /// 创建时间
        /// </summary>
        [SqlSugar.SugarColumn(ColumnName = "createTime", IsNullable = true)]
        public DateTime? createTime { get; set; }

        /// <summary>
        /// 更新时间
        /// </summary>
        [SqlSugar.SugarColumn(ColumnName = "updateTime", IsNullable = true)]
        public DateTime? updateTime { get; set; }
    }
}
